USE Liberty
GO

---------------------------------------------------------------------------------------------------
--	TypesOfMilitaryBranch Population Script
---------------------------------------------------------------------------------------------------

SET NOCOUNT ON 

IF EXISTS(SELECT 1 FROM dbo.TypesOfMilitaryBranch)
BEGIN
	PRINT 'TypesOfMilitaryBranch already populated; no action taken'
END
ELSE
BEGIN

	INSERT INTO dbo.TypesOfMilitaryBranch (Branch, DisplayOrder)
	VALUES('Marine Corps', 1)
	INSERT INTO dbo.TypesOfMilitaryBranch (Branch, DisplayOrder)
	VALUES('Navy', 2)
	INSERT INTO dbo.TypesOfMilitaryBranch (Branch, DisplayOrder)
	VALUES('Army', 3)
	INSERT INTO dbo.TypesOfMilitaryBranch (Branch, DisplayOrder)
	VALUES('Air Force', 4)
	INSERT INTO dbo.TypesOfMilitaryBranch (Branch, DisplayOrder)
	VALUES('Coast Guard', 5)

	PRINT 'TypesOfMilitaryBranch has been populated'
END

SELECT * FROM dbo.TypesOfMilitaryBranch

